package net.wantongtech.xa.uploadbasicinfo.dao;

import com.wtkj.dao.impl.BaseDataTemplate;
import com.wtkj.zwxt.clearing.vo.push.TransactionVo;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.stereotype.Repository;

import java.util.List;


@Repository
public class CreateCMBCTransPackageDao extends BaseDataTemplate {

    public List<TransactionVo> querySendingTransaction() {
        final String sql =
                "SELECT TR.TRANSACTIONID AS INTEGRATEDID,\n" +
                        "       TR.TRANSTIME AS EXTIME,\n" +
                        "       TR.FEE,\n" +
                        "       TR.ENTIME,\n" +
                        "       TR.ETCCARDID AS CARDID,\n" +
                        "       TR.OBUID AS OBUNO,\n" +
                        "       TR.ENTOLLSTATIONNAME,\n" +
                        "       TR.EXTOLLSTATIONNAME,\n" +
                        "       TR.TOLLPROVINCEID,\n" +
                        "       DECODE(TR.TOLLPROVINCEID, '610201', 1, 0) AS INPROVINCE,\n" +
                        "       TR.SERVICETYPE,\n" +
                        "       TR.OBUSIGN,\n" +
                        "       TR.DESCRIPTION,\n" +
                        "       1 AS COUNT\n" +
                        "  FROM TR_PORTAL_TRANSOUT TR\n" +
                        " WHERE TR.TRANSACTIONID IN\n" +
                        "       ('G0065500020004100102020022413100158',\n" +
                        "        'G5001500010013200102020022414100054',\n" +
                        "        'G0065500010001200102020022415100086',\n" +
                        "        'G5001500010015200102020022414100025',\n" +
                        "        'G5001500010012200102020022414100050',\n" +
                        "        'G0069500030001200102020022413100060',\n" +
                        "        'G5001500010010200102020022414100063',\n" +
                        "        'G0069500030003200102020022412100183',\n" +
                        "        'G5001500010007200102020022414100115',\n" +
                        "        'G0065500010005200102020022414100256',\n" +
                        "        'G5001500010016200102020022413100378',\n" +
                        "        'G0065500010004200102020022414100249',\n" +
                        "        'G0065500010002200102020022415100043',\n" +
                        "        'G0065500020006100102020022413100331',\n" +
                        "        'G5001500010008200102020022414100093',\n" +
                        "        'G0065500010003200102020022415100026',\n" +
                        "        'G0069500030004200102020022412100094',\n" +
                        "        'G0069500030002200102020022413100026',\n" +
                        "        'G5001500010011200102020022414100074',\n" +
                        "        'G0065500020007100102020022413100403',\n" +
                        "        'G5001500010014200102020022414100036',\n" +
                        "        'G0065500020005100102020022413100252',\n" +
                        "        'G0065510020006200102020022416100281',\n" +
                        "        'G0065510010004200102020022418100158',\n" +
                        "        'G0065510010007200102020022417100310',\n" +
                        "        'G0065510020014200102020022415100256',\n" +
                        "        'G0065510010005200102020022418100094',\n" +
                        "        'G0065510020009200102020022416100007',\n" +
                        "        'G0065510010001200102020022418100196',\n" +
                        "        'G0065510010009200102020022417100339',\n" +
                        "        'G0065510020005200102020022416100272',\n" +
                        "        'G0065510020008200102020022416100088',\n" +
                        "        'G0065510020004200102020022416100564',\n" +
                        "        'G0065510020002200102020022416100471',\n" +
                        "        'G0065510020015200102020022415100094',\n" +
                        "        'G0065510020016200102020022416100418',\n" +
                        "        'G0065510020011200102020022415100354',\n" +
                        "        'G0065510020010200102020022415100334',\n" +
                        "        'G0065510010010200102020022417100291',\n" +
                        "        'G0065510020003200102020022416100446',\n" +
                        "        'G0065510010003200102020022418100150',\n" +
                        "        'G0065510010006200102020022418100080',\n" +
                        "        'G0065510010011200102020022417100142',\n" +
                        "        'G0065510010008200102020022417100319',\n" +
                        "        'G0065510020007200102020022416100104',\n" +
                        "        'G0065510010002200102020022418100190',\n" +
                        "        'G0065510010012200102020022417100040',\n" +
                        "        'G0065510020001200102020022416100514',\n" +
                        "        'G0030620010007200102020030413200070',\n" +
                        "        'G0022620030016100102020030414020024',\n" +
                        "        'G0022620030001200102020030415100178',\n" +
                        "        'G0070620010002200102020030415100244',\n" +
                        "        'G0022620030003200102020030415100093',\n" +
                        "        'G0022620030002200102020030415200161',\n" +
                        "        'G0022620030007200102020030414200261',\n" +
                        "        'G0070620010001200102020030415100247',\n" +
                        "        'G0022620030006200102020030414200321',\n" +
                        "        'G0030620010004200102020030413200007',\n" +
                        "        'G0022620030004200102020030415200050',\n" +
                        "        'G0022620030005200102020030414200299',\n" +
                        "        'G0030620010008100102020030412020008',\n" +
                        "        'G0030620010002200102020030412100047',\n" +
                        "        'G0030620010006200102020030413200053',\n" +
                        "        'G0030620010005200102020030413100051',\n" +
                        "        'G0030620010003200102020030412200057',\n" +
                        "        'G0022620020007100102020030510010007',\n" +
                        "        'G0070620010001200102020030510100241',\n" +
                        "        'G0022620020003100102020030510100052',\n" +
                        "        'G0022620020004100102020030510100058',\n" +
                        "        'G0022620020005100102020030510200075',\n" +
                        "        'G0070620010002200102020030510100233',\n" +
                        "        'G0040410030052100102020030618200181',\n" +
                        "        'S0083410040059100102020030617200186',\n" +
                        "        'G0040410030053100102020030618200274',\n" +
                        "        'S0083410040057100102020030617100106',\n" +
                        "        'G0040410040055100102020030620100064',\n" +
                        "        'S0083410050051100102020030618100072',\n" +
                        "        'G0036410010053100102020030615200785',\n" +
                        "        'G0040410030055100102020030619200165',\n" +
                        "        'G0036410010055100102020030616100097',\n" +
                        "        'S0083410040058100102020030617100172',\n" +
                        "        'G0040410040051100102020030619100230',\n" +
                        "        'S0083410040060100102020030618200019',\n" +
                        "        'G0036410020051100102020030616100310',\n" +
                        "        'S0083410040070200102020030618200222',\n" +
                        "        'G0040410040054100102020030620200029',\n" +
                        "        'G0040410040053100102020030619200259',\n" +
                        "        'S0083410040101100102020030618100019',\n" +
                        "        'G0036410010058100102020030616200262',\n" +
                        "        'G0036410020053100102020030617100023',\n" +
                        "        'G0040410030056100102020030619200151',\n" +
                        "        'G0040410040052100102020030619200236',\n" +
                        "        'G0040410020060100102020030618200158',\n" +
                        "        'S0083410040070200102020030618110431',\n" +
                        "        'G0036410020054100102020030617100165',\n" +
                        "        'G0036410010052100102020030615200189',\n" +
                        "        'G0036410010054100102020030615101065',\n" +
                        "        'G0040410030054100102020030618100280',\n" +
                        "        'S0083410040056100102020030617100087',\n" +
                        "        'G0040410040056100102020030620100070',\n" +
                        "        'G0036410010056100102020030616200151',\n" +
                        "        'G0040410020059100102020030618100155',\n" +
                        "        'G0036410010051100102020030615100077',\n" +
                        "        'G0036410010057100102020030616200322',\n" +
                        "        'S0083410050052100102020030618200077',\n" +
                        "        'G0036410020052100102020030616100296',\n" +
                        "        'S0028410050053200102020031120200038',\n" +
                        "        'G0055410020053200102020031119200339',\n" +
                        "        'G0030410040058200102020031119100189',\n" +
                        "        'G5512410040053200102020031120200290',\n" +
                        "        'G5512410030054200102020031120100370',\n" +
                        "        'G5512410030020200102020031121123506',\n" +
                        "        'G5512410040054200102020031120200320',\n" +
                        "        'G0030410050055200102020031118200041',\n" +
                        "        'G0030410040059200102020031119200120',\n" +
                        "        'G0055410020054200102020031119200385',\n" +
                        "        'G0030410040054200102020031119200429',\n" +
                        "        'G5512410040052200102020031120100200',\n" +
                        "        'S0028410050054200102020031120100081',\n" +
                        "        'G0030410050051200102020031118100708',\n" +
                        "        'S0028410050052200102020031120100030',\n" +
                        "        'G5512410040055200102020031120100303',\n" +
                        "        'G0030410050057200102020031117200546',\n" +
                        "        'G0030410040056200102020031119200363',\n" +
                        "        'G0030410050053200102020031118200227',\n" +
                        "        'G0030410040057200102020031119100343',\n" +
                        "        'G0030410050056200102020031117200730',\n" +
                        "        'S0028410050055200102020031120100220',\n" +
                        "        'G0030410050052200102020031118100437',\n" +
                        "        'G0055410020052200102020031119200412',\n" +
                        "        'G0030410050059200102020031117100356',\n" +
                        "        'G0030410050054200102020031118100063',\n" +
                        "        'G5512410040051200102020031120100185',\n" +
                        "        'G0030410040060200102020031119200072',\n" +
                        "        'G0030410040055200102020031119200383',\n" +
                        "        'G0030410050058200102020031117100407',\n" +
                        "        'G0004410020060200102020031217201444',\n" +
                        "        'G0004410020090200102020031217500138',\n" +
                        "        'G0004410020062200102020031217101358',\n" +
                        "        'G0004410010060200102020031218100856',\n" +
                        "        'G0004410020056200102020031218100341',\n" +
                        "        'G0004410010059200102020031219200003',\n" +
                        "        'G0004410020061200102020031217101381',\n" +
                        "        'G0004410020055200102020031218200525',\n" +
                        "        'G0004410020057200102020031218100146',\n" +
                        "        'G0004410020054200102020031218200567',\n" +
                        "        'G0004410020059200102020031218100045',\n" +
                        "        'G0004410020058200102020031218200078',\n" +
                        "        'G0004410020065200102020031217201085',\n" +
                        "        'G0004410020058100102020031411100489',\n" +
                        "        'G0004410020065100102020031411100639',\n" +
                        "        'G0004410020057100102020031411100478',\n" +
                        "        'G0004410020060100102020031411200659',\n" +
                        "        'G0004410010060100102020031410100883',\n" +
                        "        'G0004410020056100102020031411200157',\n" +
                        "        'G0004410020059100102020031411100532',\n" +
                        "        'G0004410010059100102020031410200575',\n" +
                        "        'G0004410020055100102020031410100779',\n" +
                        "        'G0004410020090200102020031411403696',\n" +
                        "        'G0004410020061100102020031411100678',\n" +
                        "        'G0004410020062100102020031411200707',\n" +
                        "        'G0004410020054100102020031410100779',\n" +
                        "        'G0030410050059100102020031519100094',\n" +
                        "        'G3001410010063200102020031515100347',\n" +
                        "        'G0030410030066100102020031516200224',\n" +
                        "        'G0030410050058100102020031519200039',\n" +
                        "        'G0030410040057100102020031516100844',\n" +
                        "        'G3001410010056200102020031515100568',\n" +
                        "        'G0030410040058100102020031517200113',\n" +
                        "        'G0030410040052100102020031516200507',\n" +
                        "        'G0030410050057100102020031518100660',\n" +
                        "        'G0030410030065100102020031516200143',\n" +
                        "        'G3001410010053200102020031515100588',\n" +
                        "        'G0004410020090200102020031515134724',\n" +
                        "        'G0030410040055100102020031516100764',\n" +
                        "        'G3001410010054200102020031515100650',\n" +
                        "        'G0030410050056100102020031518200495',\n" +
                        "        'G0030410050053100102020031518100172',\n" +
                        "        'G0030410040059100102020031517100168',\n" +
                        "        'G3001410010060200102020031515100426',\n" +
                        "        'G0030410030063100102020031515200893',\n" +
                        "        'G0030410040053100102020031516200503',\n" +
                        "        'G0030410050055100102020031518200383',\n" +
                        "        'G0030410050054100102020031518200339',\n" +
                        "        'G3001410010052200102020031515100603',\n" +
                        "        'G0030410050052100102020031517200933',\n" +
                        "        'G3001410010057200102020031515200498',\n" +
                        "        'G3001410010055200102020031515100640',\n" +
                        "        'G0030410040060100102020031517100209',\n" +
                        "        'G3001410010058200102020031515100459',\n" +
                        "        'G3001410010062200102020031515200403',\n" +
                        "        'G0030410040054100102020031516200682',\n" +
                        "        'S0001410010051200102020031515200286',\n" +
                        "        'G3001410010051200102020031515100608',\n" +
                        "        'G0030410040051100102020031516100391',\n" +
                        "        'G0030410030064100102020031515200868',\n" +
                        "        'G3001410010061200102020031515200387',\n" +
                        "        'G0030410050055100102020031617200706',\n" +
                        "        'S0032410020051100102020031614100396',\n" +
                        "        'G0030410050058100102020031618200286',\n" +
                        "        'G0030410050057100102020031618100046',\n" +
                        "        'S0032410030010200102020031614202837',\n" +
                        "        'G0030410050059200102020031621100171',\n" +
                        "        'G0036410050055100102020031615200506',\n" +
                        "        'S0085410020053100102020031615100140',\n" +
                        "        'S0059410010054100102020031622100021',\n" +
                        "        'G0030410040060100102020031616100450',\n" +
                        "        'G0030410050058200102020031621200204',\n" +
                        "        'G0030410050052100102020031616200942',\n" +
                        "        'S0059410010055100102020031622200039',\n" +
                        "        'S0085410020054100102020031615200125',\n" +
                        "        'G0030410050056100102020031617200776',\n" +
                        "        'G0036410050057100102020031616200025',\n" +
                        "        'G0030410040058100102020031616200372',\n" +
                        "        'G0036410050052100102020031615100429',\n" +
                        "        'G0030410050053100102020031617100261',\n" +
                        "        'S0059410010053100102020031622200003',\n" +
                        "        'G0036410050054100102020031615100467',\n" +
                        "        'S0059410010030200102020031622534688',\n" +
                        "        'S0085410010057100102020031614200559',\n" +
                        "        'S0085410020051100102020031614100473',\n" +
                        "        'G0030410050056200102020031621100439',\n" +
                        "        'G0030410050059100102020031618100333',\n" +
                        "        'G0036410050053100102020031615200420',\n" +
                        "        'G0036410050056100102020031615200625',\n" +
                        "        'G0036410050051100102020031615200493',\n" +
                        "        'G0030410050051100102020031616200693',\n" +
                        "        'G0030410050054100102020031617200600',\n" +
                        "        'S0085410020055100102020031615200203',\n" +
                        "        'S0059410010051100102020031622100001',\n" +
                        "        'G0030410050057200102020031621200333',\n" +
                        "        'G0030410040059100102020031616100408',\n" +
                        "        'S0085410020052100102020031614100455',\n" +
                        "        'G0065500020003100102020022413100112')\n";
        return jdbcTemplate.query(sql, BeanPropertyRowMapper.newInstance(TransactionVo.class));
    }

}
